Overview
Brought to you by YData
Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 1696240 |
| Missing cells | 6 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 562.2 MiB |
| Average record size in memory | 347.5 B |
Variable types
| Text | 2 |
|---|---|
| Numeric | 7 |
| DateTime | 1 |
| Categorical | 3 |
game_id is highly overall correlated with player_id | High correlation |
player_club_id is highly overall correlated with player_current_club_id | High correlation |
player_current_club_id is highly overall correlated with player_club_id | High correlation |
player_id is highly overall correlated with game_id | High correlation |
yellow_cards is highly imbalanced (60.9%) | Imbalance |
red_cards is highly imbalanced (96.4%) | Imbalance |
appearance_id has unique values | Unique |
goals has 1550722 (91.4%) zeros | Zeros |
assists has 1577536 (93.0%) zeros | Zeros |
Reproduction
| Analysis started | 2025-03-12 19:10:34.392723 |
|---|---|
| Analysis finished | 2025-03-12 19:11:10.494902 |
| Duration | 36.1 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
appearance_id
Text
Unique 
| Distinct | 1696240 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.2 MiB |
Length
| Max length | 15 |
|---|---|
| Median length | 14 |
| Mean length | 13.575551 |
| Min length | 10 |
Unique
| Unique | 1696240 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 2231978_38004 |
|---|---|
| 2nd row | 2233748_79232 |
| 3rd row | 2234413_42792 |
| 4th row | 2234418_73333 |
| 5th row | 2234421_122011 |
| Value | Count | Frequency (%) |
| 2231978_38004 | 1 | < 0.1% |
| 2235545_4582 | 1 | < 0.1% |
| 2234421_122011 | 1 | < 0.1% |
| 2234421_146889 | 1 | < 0.1% |
| 2235539_28716 | 1 | < 0.1% |
| 2235539_69445 | 1 | < 0.1% |
| 2235545_19409 | 1 | < 0.1% |
| 2235545_30003 | 1 | < 0.1% |
| 2235545_30667 | 1 | < 0.1% |
| 2235545_34129 | 1 | < 0.1% |
| Other values (1696230) | 1696230 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 3089752 | |
| 3 | 2757615 | |
| 4 | 2296835 | |
| 1 | 2189354 | |
| 8 | 1942858 | |
| 5 | 1926692 | |
| 9 | 1811798 | |
| 0 | 1806407 | |
| 6 | 1786878 | |
| 7 | 1722963 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 23027392 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 3089752 | |
| 3 | 2757615 | |
| 4 | 2296835 | |
| 1 | 2189354 | |
| 8 | 1942858 | |
| 5 | 1926692 | |
| 9 | 1811798 | |
| 0 | 1806407 | |
| 6 | 1786878 | |
| 7 | 1722963 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 23027392 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 3089752 | |
| 3 | 2757615 | |
| 4 | 2296835 | |
| 1 | 2189354 | |
| 8 | 1942858 | |
| 5 | 1926692 | |
| 9 | 1811798 | |
| 0 | 1806407 | |
| 6 | 1786878 | |
| 7 | 1722963 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 23027392 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 3089752 | |
| 3 | 2757615 | |
| 4 | 2296835 | |
| 1 | 2189354 | |
| 8 | 1942858 | |
| 5 | 1926692 | |
| 9 | 1811798 | |
| 0 | 1806407 | |
| 6 | 1786878 | |
| 7 | 1722963 |
game_id
Real number (ℝ)
High correlation 
| Distinct | 66489 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3158399.9 |
| Minimum | 2211607 |
|---|---|
| Maximum | 4570633 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 2211607 |
|---|---|
| 5-th percentile | 2250206 |
| Q1 | 2588911 |
| median | 3080230 |
| Q3 | 3615124 |
| 95-th percentile | 4367902 |
| Maximum | 4570633 |
| Range | 2359026 |
| Interquartile range (IQR) | 1026213 |
Descriptive statistics
| Standard deviation | 659964.01 |
|---|---|
| Coefficient of variation (CV) | 0.20895518 |
| Kurtosis | -1.079163 |
| Mean | 3158399.9 |
| Median Absolute Deviation (MAD) | 522868 |
| Skewness | 0.33004758 |
| Sum | 5.3574042 × 1012 |
| Variance | 4.355525 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2884392 | 36 | < 0.1% |
| 4098010 | 35 | < 0.1% |
| 4545866 | 35 | < 0.1% |
| 2740103 | 34 | < 0.1% |
| 4041615 | 34 | < 0.1% |
| 4002937 | 34 | < 0.1% |
| 4243699 | 34 | < 0.1% |
| 4243720 | 34 | < 0.1% |
| 4547624 | 34 | < 0.1% |
| 4148218 | 34 | < 0.1% |
| Other values (66479) | 1695896 |
| Value | Count | Frequency (%) |
| 2211607 | 27 | |
| 2218677 | 28 | |
| 2219794 | 28 | |
| 2219795 | 28 | |
| 2221641 | 14 | |
| 2221747 | 1 | < 0.1% |
| 2221748 | 1 | < 0.1% |
| 2221749 | 14 | |
| 2221751 | 14 | |
| 2221753 | 14 |
| Value | Count | Frequency (%) |
| 4570633 | 27 | |
| 4562600 | 32 | |
| 4562599 | 31 | |
| 4562598 | 32 | |
| 4562597 | 14 | |
| 4562596 | 30 | |
| 4562595 | 17 | |
| 4562593 | 14 | |
| 4559306 | 32 | |
| 4559305 | 29 |
player_id
Real number (ℝ)
High correlation 
| Distinct | 25664 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 208378.94 |
| Minimum | 10 |
|---|---|
| Maximum | 1380876 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 15452 |
| Q1 | 58252 |
| median | 148396 |
| Q3 | 300168 |
| 95-th percentile | 603149 |
| Maximum | 1380876 |
| Range | 1380866 |
| Interquartile range (IQR) | 241916 |
Descriptive statistics
| Standard deviation | 192896.79 |
|---|---|
| Coefficient of variation (CV) | 0.92570193 |
| Kurtosis | 2.1678302 |
| Mean | 208378.94 |
| Median Absolute Deviation (MAD) | 103452 |
| Skewness | 1.4389129 |
| Sum | 3.534607 × 1011 |
| Variance | 3.7209171 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 38253 | 605 | < 0.1% |
| 32467 | 578 | < 0.1% |
| 59561 | 563 | < 0.1% |
| 125781 | 563 | < 0.1% |
| 74229 | 560 | < 0.1% |
| 36139 | 558 | < 0.1% |
| 28396 | 558 | < 0.1% |
| 56416 | 551 | < 0.1% |
| 91845 | 549 | < 0.1% |
| 65278 | 545 | < 0.1% |
| Other values (25654) | 1690610 |
| Value | Count | Frequency (%) |
| 10 | 136 | |
| 26 | 152 | |
| 65 | 122 | |
| 77 | 4 | < 0.1% |
| 80 | 12 | < 0.1% |
| 109 | 41 | < 0.1% |
| 123 | 7 | < 0.1% |
| 132 | 77 | |
| 215 | 109 | |
| 258 | 19 | < 0.1% |
| Value | Count | Frequency (%) |
| 1380876 | 1 | < 0.1% |
| 1378362 | 1 | < 0.1% |
| 1358447 | 1 | < 0.1% |
| 1310513 | 3 | < 0.1% |
| 1309326 | 3 | < 0.1% |
| 1306851 | 8 | |
| 1302421 | 5 | |
| 1294052 | 11 | |
| 1294049 | 5 | |
| 1294048 | 2 | < 0.1% |
player_club_id
Real number (ℝ)
High correlation 
| Distinct | 1064 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3124.6588 |
| Minimum | 1 |
|---|---|
| Maximum | 116786 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 27 |
| Q1 | 289 |
| median | 826 |
| Q3 | 2441 |
| 95-th percentile | 16239 |
| Maximum | 116786 |
| Range | 116785 |
| Interquartile range (IQR) | 2152 |
Descriptive statistics
| Standard deviation | 8249.8986 |
|---|---|
| Coefficient of variation (CV) | 2.6402558 |
| Kurtosis | 37.534466 |
| Mean | 3124.6588 |
| Median Absolute Deviation (MAD) | 626 |
| Skewness | 5.5673787 |
| Sum | 5.3001712 × 109 |
| Variance | 68060826 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 418 | 10257 | 0.6% |
| 131 | 10166 | 0.6% |
| 368 | 9983 | 0.6% |
| 506 | 9644 | 0.6% |
| 985 | 9631 | 0.6% |
| 281 | 9571 | 0.6% |
| 631 | 9554 | 0.6% |
| 31 | 9443 | 0.6% |
| 371 | 9358 | 0.6% |
| 27 | 9324 | 0.5% |
| Other values (1054) | 1599309 |
| Value | Count | Frequency (%) |
| 1 | 3 | < 0.1% |
| 2 | 13 | < 0.1% |
| 3 | 4896 | |
| 4 | 1501 | 0.1% |
| 5 | 8964 | |
| 6 | 467 | < 0.1% |
| 9 | 4 | < 0.1% |
| 10 | 1087 | 0.1% |
| 11 | 9290 | |
| 12 | 9022 |
| Value | Count | Frequency (%) |
| 116786 | 2 | < 0.1% |
| 110302 | 361 | |
| 101634 | 1 | < 0.1% |
| 101362 | 3 | < 0.1% |
| 99200 | 2 | < 0.1% |
| 91328 | 3 | < 0.1% |
| 87883 | 1 | < 0.1% |
| 86209 | 285 | |
| 85465 | 327 | |
| 83678 | 445 |
player_current_club_id
Real number (ℝ)
High correlation 
| Distinct | 438 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3979.587 |
| Minimum | -1 |
|---|---|
| Maximum | 110302 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 6 |
| Negative (%) | < 0.1% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 331 |
| median | 903 |
| Q3 | 2696 |
| 95-th percentile | 19771 |
| Maximum | 110302 |
| Range | 110303 |
| Interquartile range (IQR) | 2365 |
Descriptive statistics
| Standard deviation | 10806.832 |
|---|---|
| Coefficient of variation (CV) | 2.7155662 |
| Kurtosis | 30.513925 |
| Mean | 3979.587 |
| Median Absolute Deviation (MAD) | 713 |
| Skewness | 5.1000201 |
| Sum | 6.7503347 × 109 |
| Variance | 1.1678762 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 36 | 11702 | 0.7% |
| 683 | 10785 | 0.6% |
| 1091 | 10266 | 0.6% |
| 150 | 10255 | 0.6% |
| 46 | 10109 | 0.6% |
| 141 | 10108 | 0.6% |
| 13 | 9981 | 0.6% |
| 2381 | 9958 | 0.6% |
| 368 | 9628 | 0.6% |
| 589 | 9498 | 0.6% |
| Other values (428) | 1593950 |
| Value | Count | Frequency (%) |
| -1 | 6 | < 0.1% |
| 3 | 4765 | |
| 4 | 987 | 0.1% |
| 5 | 8638 | |
| 6 | 618 | < 0.1% |
| 10 | 1190 | 0.1% |
| 11 | 7593 | |
| 12 | 8008 | |
| 13 | 9981 | |
| 15 | 7461 |
| Value | Count | Frequency (%) |
| 110302 | 2320 | |
| 86209 | 729 | < 0.1% |
| 85465 | 1892 | 0.1% |
| 83678 | 769 | < 0.1% |
| 75231 | 824 | < 0.1% |
| 71985 | 1222 | 0.1% |
| 68608 | 1977 | |
| 63007 | 2555 | |
| 61825 | 2392 | |
| 60949 | 4824 |
date
Date
| Distinct | 3717 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.9 MiB |
| Minimum | 2012-07-03 00:00:00 |
|---|---|
| Maximum | 2025-03-10 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
player_name
Text
| Distinct | 25119 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 6 |
| Missing (%) | < 0.1% |
| Memory size | 126.2 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 13.473428 |
| Min length | 2 |
Unique
| Unique | 2111 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Aurélien Joachim |
|---|---|
| 2nd row | Ruslan Abyshov |
| 3rd row | Sander Puri |
| 4th row | Vegar Hedenstad |
| 5th row | Markus Henriksen |
| Value | Count | Frequency (%) |
| de | 14398 | 0.4% |
| van | 14237 | 0.4% |
| david | 11680 | 0.3% |
| lucas | 9957 | 0.3% |
| thomas | 8444 | 0.3% |
| kevin | 7908 | 0.2% |
| daniel | 7764 | 0.2% |
| andré | 7245 | 0.2% |
| pedro | 7121 | 0.2% |
| joão | 7084 | 0.2% |
| Other values (23832) | 3280994 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2268340 | 9.9% |
| e | 1733616 | 7.6% |
| 1680598 | 7.4% | |
| i | 1628621 | 7.1% |
| o | 1530209 | 6.7% |
| n | 1496563 | 6.5% |
| r | 1419771 | 6.2% |
| l | 991297 | 4.3% |
| s | 990515 | 4.3% |
| t | 678702 | 3.0% |
| Other values (111) | 8435854 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 22854086 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 2268340 | 9.9% |
| e | 1733616 | 7.6% |
| 1680598 | 7.4% | |
| i | 1628621 | 7.1% |
| o | 1530209 | 6.7% |
| n | 1496563 | 6.5% |
| r | 1419771 | 6.2% |
| l | 991297 | 4.3% |
| s | 990515 | 4.3% |
| t | 678702 | 3.0% |
| Other values (111) | 8435854 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 22854086 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 2268340 | 9.9% |
| e | 1733616 | 7.6% |
| 1680598 | 7.4% | |
| i | 1628621 | 7.1% |
| o | 1530209 | 6.7% |
| n | 1496563 | 6.5% |
| r | 1419771 | 6.2% |
| l | 991297 | 4.3% |
| s | 990515 | 4.3% |
| t | 678702 | 3.0% |
| Other values (111) | 8435854 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 22854086 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 2268340 | 9.9% |
| e | 1733616 | 7.6% |
| 1680598 | 7.4% | |
| i | 1628621 | 7.1% |
| o | 1530209 | 6.7% |
| n | 1496563 | 6.5% |
| r | 1419771 | 6.2% |
| l | 991297 | 4.3% |
| s | 990515 | 4.3% |
| t | 678702 | 3.0% |
| Other values (111) | 8435854 |
competition_id
Categorical
| Distinct | 43 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 97.0 MiB |
| IT1 | |
|---|---|
| ES1 | |
| GB1 | |
| FR1 | |
| TR1 | |
| Other values (38) |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 2.932575 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CLQ |
|---|---|
| 2nd row | ELQ |
| 3rd row | ELQ |
| 4th row | ELQ |
| 5th row | ELQ |
Common Values
| Value | Count | Frequency (%) |
| IT1 | 139849 | 8.2% |
| ES1 | 138147 | 8.1% |
| GB1 | 135091 | 8.0% |
| FR1 | 131229 | 7.7% |
| TR1 | 119614 | 7.1% |
| L1 | 112441 | 6.6% |
| NL1 | 107748 | 6.4% |
| PO1 | 107305 | 6.3% |
| BE1 | 92929 | 5.5% |
| RU1 | 85204 | 5.0% |
| Other values (33) | 526683 |
Length
| Value | Count | Frequency (%) |
| it1 | 139849 | 8.2% |
| es1 | 138147 | 8.1% |
| gb1 | 135091 | 8.0% |
| fr1 | 131229 | 7.7% |
| tr1 | 119614 | 7.1% |
| l1 | 112441 | 6.6% |
| nl1 | 107748 | 6.4% |
| po1 | 107305 | 6.3% |
| be1 | 92929 | 5.5% |
| ru1 | 85204 | 5.0% |
| Other values (33) | 526683 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 1451827 | |
| R | 532301 | 10.7% |
| L | 353586 | 7.1% |
| E | 302983 | 6.1% |
| T | 269688 | 5.4% |
| B | 241271 | 4.9% |
| G | 232914 | 4.7% |
| S | 222972 | 4.5% |
| C | 183742 | 3.7% |
| P | 176424 | 3.5% |
| Other values (10) | 1006643 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4974351 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1451827 | |
| R | 532301 | 10.7% |
| L | 353586 | 7.1% |
| E | 302983 | 6.1% |
| T | 269688 | 5.4% |
| B | 241271 | 4.9% |
| G | 232914 | 4.7% |
| S | 222972 | 4.5% |
| C | 183742 | 3.7% |
| P | 176424 | 3.5% |
| Other values (10) | 1006643 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4974351 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1451827 | |
| R | 532301 | 10.7% |
| L | 353586 | 7.1% |
| E | 302983 | 6.1% |
| T | 269688 | 5.4% |
| B | 241271 | 4.9% |
| G | 232914 | 4.7% |
| S | 222972 | 4.5% |
| C | 183742 | 3.7% |
| P | 176424 | 3.5% |
| Other values (10) | 1006643 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4974351 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1451827 | |
| R | 532301 | 10.7% |
| L | 353586 | 7.1% |
| E | 302983 | 6.1% |
| T | 269688 | 5.4% |
| B | 241271 | 4.9% |
| G | 232914 | 4.7% |
| S | 222972 | 4.5% |
| C | 183742 | 3.7% |
| P | 176424 | 3.5% |
| Other values (10) | 1006643 |
yellow_cards
Categorical
Imbalance 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 93.8 MiB |
| 0 | |
|---|---|
| 1 | |
| 2 | 6750 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 1453054 | |
| 1 | 236436 | 13.9% |
| 2 | 6750 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 1453054 | |
| 1 | 236436 | 13.9% |
| 2 | 6750 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1453054 | |
| 1 | 236436 | 13.9% |
| 2 | 6750 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1696240 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1453054 | |
| 1 | 236436 | 13.9% |
| 2 | 6750 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1696240 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1453054 | |
| 1 | 236436 | 13.9% |
| 2 | 6750 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1696240 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1453054 | |
| 1 | 236436 | 13.9% |
| 2 | 6750 | 0.4% |
red_cards
Categorical
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 93.8 MiB |
| 0 | |
|---|---|
| 1 | 6414 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 1689826 | |
| 1 | 6414 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 1689826 | |
| 1 | 6414 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1689826 | |
| 1 | 6414 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1696240 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1689826 | |
| 1 | 6414 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1696240 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1689826 | |
| 1 | 6414 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1696240 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1689826 | |
| 1 | 6414 | 0.4% |
goals
Real number (ℝ)
Zeros 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.095945149 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 1550722 |
| Zeros (%) | 91.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.33104245 |
|---|---|
| Coefficient of variation (CV) | 3.4503302 |
| Kurtosis | 17.871909 |
| Mean | 0.095945149 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.8743458 |
| Sum | 162746 |
| Variance | 0.1095891 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1550722 | |
| 1 | 130219 | 7.7% |
| 2 | 13566 | 0.8% |
| 3 | 1562 | 0.1% |
| 4 | 147 | < 0.1% |
| 5 | 23 | < 0.1% |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 1550722 | |
| 1 | 130219 | 7.7% |
| 2 | 13566 | 0.8% |
| 3 | 1562 | 0.1% |
| 4 | 147 | < 0.1% |
| 5 | 23 | < 0.1% |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6 | 1 | < 0.1% |
| 5 | 23 | < 0.1% |
| 4 | 147 | < 0.1% |
| 3 | 1562 | 0.1% |
| 2 | 13566 | 0.8% |
| 1 | 130219 | 7.7% |
| 0 | 1550722 |
assists
Real number (ℝ)
Zeros 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.075449818 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 1577536 |
| Zeros (%) | 93.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.28542358 |
|---|---|
| Coefficient of variation (CV) | 3.7829591 |
| Kurtosis | 18.381635 |
| Mean | 0.075449818 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.0511378 |
| Sum | 127981 |
| Variance | 0.081466619 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1577536 | |
| 1 | 110036 | 6.5% |
| 2 | 8100 | 0.5% |
| 3 | 530 | < 0.1% |
| 4 | 36 | < 0.1% |
| 5 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 1577536 | |
| 1 | 110036 | 6.5% |
| 2 | 8100 | 0.5% |
| 3 | 530 | < 0.1% |
| 4 | 36 | < 0.1% |
| 5 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 4 | 36 | < 0.1% |
| 3 | 530 | < 0.1% |
| 2 | 8100 | 0.5% |
| 1 | 110036 | 6.5% |
| 0 | 1577536 |
minutes_played
Real number (ℝ)
| Distinct | 122 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 69.08907 |
| Minimum | 1 |
|---|---|
| Maximum | 148 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 45 |
| median | 90 |
| Q3 | 90 |
| 95-th percentile | 90 |
| Maximum | 148 |
| Range | 147 |
| Interquartile range (IQR) | 45 |
Descriptive statistics
| Standard deviation | 29.981579 |
|---|---|
| Coefficient of variation (CV) | 0.43395546 |
| Kurtosis | -0.38137054 |
| Mean | 69.08907 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.0701779 |
| Sum | 1.1719164 × 108 |
| Variance | 898.89508 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 90 | 907180 | |
| 45 | 66235 | 3.9% |
| 1 | 26371 | 1.6% |
| 78 | 11748 | 0.7% |
| 12 | 11618 | 0.7% |
| 76 | 11593 | 0.7% |
| 77 | 11549 | 0.7% |
| 14 | 11507 | 0.7% |
| 75 | 11498 | 0.7% |
| 74 | 11495 | 0.7% |
| Other values (112) | 615446 |
| Value | Count | Frequency (%) |
| 1 | 26371 | |
| 2 | 7796 | 0.5% |
| 3 | 8545 | 0.5% |
| 4 | 9092 | 0.5% |
| 5 | 9663 | 0.6% |
| 6 | 10271 | 0.6% |
| 7 | 10756 | |
| 8 | 11084 | |
| 9 | 11253 | |
| 10 | 11241 |
| Value | Count | Frequency (%) |
| 148 | 1 | < 0.1% |
| 135 | 2 | < 0.1% |
| 120 | 8143 | |
| 119 | 30 | < 0.1% |
| 118 | 30 | < 0.1% |
| 117 | 25 | < 0.1% |
| 116 | 21 | < 0.1% |
| 115 | 43 | < 0.1% |
| 114 | 28 | < 0.1% |
| 113 | 41 | < 0.1% |
Interactions
Correlations
| assists | competition_id | game_id | goals | minutes_played | player_club_id | player_current_club_id | player_id | red_cards | yellow_cards | |
|---|---|---|---|---|---|---|---|---|---|---|
| assists | 1.000 | 0.016 | -0.010 | 0.072 | 0.055 | -0.035 | -0.035 | -0.009 | 0.007 | 0.005 |
| competition_id | 0.016 | 1.000 | 0.114 | 0.016 | 0.088 | 0.166 | 0.193 | 0.069 | 0.016 | 0.045 |
| game_id | -0.010 | 0.114 | 1.000 | -0.006 | -0.111 | 0.028 | -0.043 | 0.640 | 0.007 | 0.016 |
| goals | 0.072 | 0.016 | -0.006 | 1.000 | 0.050 | -0.031 | -0.036 | -0.006 | 0.009 | 0.006 |
| minutes_played | 0.055 | 0.088 | -0.111 | 0.050 | 1.000 | -0.003 | -0.024 | -0.162 | 0.062 | 0.098 |
| player_club_id | -0.035 | 0.166 | 0.028 | -0.031 | -0.003 | 1.000 | 0.618 | 0.080 | 0.002 | 0.008 |
| player_current_club_id | -0.035 | 0.193 | -0.043 | -0.036 | -0.024 | 0.618 | 1.000 | 0.001 | 0.001 | 0.007 |
| player_id | -0.009 | 0.069 | 0.640 | -0.006 | -0.162 | 0.080 | 0.001 | 1.000 | 0.003 | 0.013 |
| red_cards | 0.007 | 0.016 | 0.007 | 0.009 | 0.062 | 0.002 | 0.001 | 0.003 | 1.000 | 0.012 |
| yellow_cards | 0.005 | 0.045 | 0.016 | 0.006 | 0.098 | 0.008 | 0.007 | 0.013 | 0.012 | 1.000 |
Missing values
Sample
| appearance_id | game_id | player_id | player_club_id | player_current_club_id | date | player_name | competition_id | yellow_cards | red_cards | goals | assists | minutes_played | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2231978_38004 | 2231978 | 38004 | 853 | 235 | 2012-07-03 | Aurélien Joachim | CLQ | 0 | 0 | 2 | 0 | 90 |
| 1 | 2233748_79232 | 2233748 | 79232 | 8841 | 2698 | 2012-07-05 | Ruslan Abyshov | ELQ | 0 | 0 | 0 | 0 | 90 |
| 2 | 2234413_42792 | 2234413 | 42792 | 6251 | 465 | 2012-07-05 | Sander Puri | ELQ | 0 | 0 | 0 | 0 | 45 |
| 3 | 2234418_73333 | 2234418 | 73333 | 1274 | 6646 | 2012-07-05 | Vegar Hedenstad | ELQ | 0 | 0 | 0 | 0 | 90 |
| 4 | 2234421_122011 | 2234421 | 122011 | 195 | 3008 | 2012-07-05 | Markus Henriksen | ELQ | 0 | 0 | 0 | 1 | 90 |
| 5 | 2234421_146889 | 2234421 | 146889 | 195 | 2778 | 2012-07-05 | Peter Ankersen | ELQ | 1 | 0 | 0 | 0 | 90 |
| 6 | 2235539_28716 | 2235539 | 28716 | 282 | 7185 | 2012-07-05 | Adi Adilovic | ELQ | 0 | 0 | 0 | 0 | 90 |
| 7 | 2235539_69445 | 2235539 | 69445 | 282 | 19771 | 2012-07-05 | Ivan Sesar | ELQ | 1 | 0 | 0 | 1 | 90 |
| 8 | 2235545_19409 | 2235545 | 19409 | 317 | 200 | 2012-07-05 | Willem Janssen | ELQ | 0 | 0 | 0 | 0 | 45 |
| 9 | 2235545_30003 | 2235545 | 30003 | 317 | 317 | 2012-07-05 | Wout Brama | ELQ | 0 | 0 | 0 | 0 | 90 |
| appearance_id | game_id | player_id | player_club_id | player_current_club_id | date | player_name | competition_id | yellow_cards | red_cards | goals | assists | minutes_played | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1696230 | 4556277_342151 | 4556277 | 342151 | 2578 | 2578 | 2025-03-10 | Daniels Balodis | SFA | 0 | 0 | 0 | 0 | 90 |
| 1696231 | 4556277_359199 | 4556277 | 359199 | 2578 | 2578 | 2025-03-10 | Andy Fisher | SFA | 0 | 0 | 0 | 0 | 90 |
| 1696232 | 4556277_430976 | 4556277 | 430976 | 2578 | 2578 | 2025-03-10 | Jonathan Svedberg | SFA | 0 | 0 | 0 | 0 | 69 |
| 1696233 | 4556277_503731 | 4556277 | 503731 | 2578 | 2578 | 2025-03-10 | Stephen Duke-McKenna | SFA | 1 | 0 | 0 | 0 | 45 |
| 1696234 | 4556277_700144 | 4556277 | 700144 | 2578 | 2578 | 2025-03-10 | Makenzie Kirk | SFA | 0 | 0 | 0 | 0 | 90 |
| 1696235 | 4556277_741267 | 4556277 | 741267 | 2578 | 2578 | 2025-03-10 | Sam Curtis | SFA | 0 | 0 | 0 | 0 | 90 |
| 1696236 | 4556277_796307 | 4556277 | 796307 | 2578 | 2578 | 2025-03-10 | Zach Mitchell | SFA | 0 | 0 | 0 | 0 | 90 |
| 1696237 | 4556277_80339 | 4556277 | 80339 | 2578 | 2578 | 2025-03-10 | Graham Carey | SFA | 0 | 0 | 1 | 0 | 21 |
| 1696238 | 4556277_909254 | 4556277 | 909254 | 1241 | 43 | 2025-03-10 | Macaulay Tait | SFA | 0 | 0 | 0 | 0 | 90 |
| 1696239 | 4556277_91854 | 4556277 | 91854 | 2578 | 2578 | 2025-03-10 | Barry Douglas | SFA | 0 | 0 | 0 | 0 | 90 |